Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Sam
 
Posts: n/a
Default Leading Zeros and decimal points

Hi,

I have a problem with leading zeros and decimal points.

The data looks like this:

176.87
25
657.9
6667.09
56.56
5.9


The data should look like this:

XXXX.XX

0176.87
0025.00
0657.90
6667.09
0056.56
0005.90

I'm able to use the custom numbers to get this result but it can't be
transfered anywhere, and the program still sees the original data.

I figure changing it to text might make a difference but I'm unsure
how. Any help appreciated.

Thanks,
Sam
  #2   Report Post  
KL
 
Posts: n/a
Default

Hi Sam,

You could use the following formula and then copy/paste values:

=TEXT(A1,"0000.00")

Regards,
KL


"Sam" wrote in message
...
Hi,

I have a problem with leading zeros and decimal points.

The data looks like this:

176.87
25
657.9
6667.09
56.56
5.9


The data should look like this:

XXXX.XX

0176.87
0025.00
0657.90
6667.09
0056.56
0005.90

I'm able to use the custom numbers to get this result but it can't be
transfered anywhere, and the program still sees the original data.

I figure changing it to text might make a difference but I'm unsure
how. Any help appreciated.

Thanks,
Sam



  #3   Report Post  
Bob Phillips
 
Posts: n/a
Default

or just use a custom format of '0000.00' if it just how it looks that
matters, as KL's method changes it to text.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"KL" wrote in message
...
Hi Sam,

You could use the following formula and then copy/paste values:

=TEXT(A1,"0000.00")

Regards,
KL


"Sam" wrote in message
...
Hi,

I have a problem with leading zeros and decimal points.

The data looks like this:

176.87
25
657.9
6667.09
56.56
5.9


The data should look like this:

XXXX.XX

0176.87
0025.00
0657.90
6667.09
0056.56
0005.90

I'm able to use the custom numbers to get this result but it can't be
transfered anywhere, and the program still sees the original data.

I figure changing it to text might make a difference but I'm unsure
how. Any help appreciated.

Thanks,
Sam





  #4   Report Post  
Sam
 
Posts: n/a
Default

On Tue, 12 Jul 2005 02:05:37 +0200, "KL"
wrote:

Hi Sam,

You could use the following formula and then copy/paste values:

=TEXT(A1,"0000.00")



Thank you.

Sam

Regards,
KL


"Sam" wrote in message
.. .
Hi,

I have a problem with leading zeros and decimal points.

The data looks like this:

176.87
25
657.9
6667.09
56.56
5.9


The data should look like this:

XXXX.XX

0176.87
0025.00
0657.90
6667.09
0056.56
0005.90

I'm able to use the custom numbers to get this result but it can't be
transfered anywhere, and the program still sees the original data.

I figure changing it to text might make a difference but I'm unsure
how. Any help appreciated.

Thanks,
Sam



Reply
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 do I get 2 zeros to show automatically after I enter. Jackson Excel Discussion (Misc queries) 7 May 3rd 06 05:31 PM
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. SUKYKITTY Excel Discussion (Misc queries) 3 July 6th 05 01:50 PM
I want to format a number cell without the decimal and without ro. LAM Excel Discussion (Misc queries) 8 April 20th 05 04:59 PM
Formating decimal and date Rick Excel Worksheet Functions 1 March 26th 05 06:10 AM
ROUND DATA TO 2 DECIMAL PLACES roy in sunbury New Users to Excel 1 January 12th 05 04:33 AM


All times are GMT +1. The time now is 02:10 PM.

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"