| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formatting
I imported data from a source. Now the numbers have a ' in front and leading
zeros. How do I re-format to get rid of them? -- STK |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formatting
Hi STK. in a helper column, say B, assuming your data is in A, in B1 type
=VALUE(A1) and copy down. Then copy column B and paste special-values over column A. HTH -- Sincerely, Michael Colvin "STK" wrote: I imported data from a source. Now the numbers have a ' in front and leading zeros. How do I re-format to get rid of them? -- STK |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
| Lost formatting in Excel | Excel Discussion (Misc queries) | |||
| How to get Excel to stop formatting time cells incorrectly | Excel Discussion (Misc queries) | |||
| Excel conditional formatting error | Excel Discussion (Misc queries) | |||
| Excel could not save all the data and formatting you recently ad.. | Excel Worksheet Functions | |||
Linear Mode
