LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Robin
 
Posts: n/a
Default format existing numbers in excel?

I have an existing spreadsheet, and I need to format existing numbers in the
cell, like 515 to 5.15 or 72957 to 729.57 without having to retype. When I
right click on the cell to format and choose number and 2 decimal places, it
adds zeros (515.00 or 72957.00) Is there ANY way to do this??
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
In Excel, how to sum top 10 greatest values in a row of numbers? Michele P Excel Worksheet Functions 4 January 19th 05 04:08 PM
I have a set of numbers in an excel spreadsheet and want to find t Charles Excel Discussion (Misc queries) 4 January 11th 05 11:39 PM
Excel Date Format - Stop? Bob Excel Worksheet Functions 4 January 11th 05 01:11 AM
How do I convert an existing MS Excel worksheet tracking a simple. [email protected] Excel Discussion (Misc queries) 0 January 4th 05 12:53 AM
How do I stop virus scans when loading existing Excel files?? C. A. Brown Excel Worksheet Functions 1 December 23rd 04 05:27 PM


All times are GMT +1. The time now is 10:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"