Product Codes Numbers - Format

[cbjroms]

I am using Excel to edit the Sage Stock Records for my business. So
export from sage as a CSV, make changes in Excel and import back int
Sage.

Generally it is working fine. But I have a problem with Product Codes


The format of my Product Code is 6 numbers and so that I can us
Excel's mathematical functions I am using a custom '000000' format.

But Sage needs the Product Code column in a text format. So prior t
import (ie having calculated the Product Code numbers) I change th
format of the Excel column to text. The problem is that, in doing this
I lose any zeros that may be the first digit of the Product Code (i
050100 becomes 50100).

How can I get around this?

Thanks in anticipation.

Chri

 

[Alex Delamain]

One suggestion - using an additional column enter the formula

=IF(LEN(A1)=5,+"0"&A1,TEXT(A1,0))

This will check if the product code has been reduced to 5 digits and
if it has, stick the initial zero back on

 

[Arvi Laanemets]

Hi

=TEXT(A2,"00000")
converts a number read from cell A2 into 5-character 0-preceeded text
string.