Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

Thread: Insert Decimal Into Whole Number

1. Insert Decimal Into Whole Number

I need to add back the decimal place into a set of numbers
i.e 4825 = 48.25
125462 = 1254.62

basically our accounting system has removed the decimal points and I need to add them back

is there a formula to do this ?

regards

Lampit

Excel Video Tutorials / Excel Dashboards Reports

2. Super Moderator
Join Date
18th November 2004
Location
God's Own Country
Posts
4,678

Re: Insert Decimal Into Whole Number

Go to Tools >Options > Edit > Fixed decimal places 2

3. Member
Join Date
9th June 2007
Posts
70

Re: Insert Decimal Into Whole Number

Hi,

If there are always two decimal places then just divide by 100

e.g. in B1

=A1/100

Eric

Excel Video Tutorials / Excel Dashboards Reports

4. Re: Insert Decimal Into Whole Number

No way for anyone or anything to know the ORGINAL number values. Check your back-up...

There are currently 2 users browsing this thread. (0 members and 2 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•
porno